<%-- 
    Document   : list
    Created on : Apr 16, 2012, 5:17:43 PM
    Author     : prateekpatil
--%>

<%@page import="java.sql.*"%>
<%
String city=request.getParameter("count");  
 String buffer="";  
 try{
 Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();  
 Connection con = DriverManager.getConnection("jdbc:oracle:thin:@fourier.cs.iit.edu:1521:orcl","ppatil2","bosu8525");  
 Statement stmt = con.createStatement();  
 ResultSet rs = stmt.executeQuery("select * from faimlypackage");  
   while(rs.next()){
   buffer="<p name='list'>"+rs.getString(1)+rs.getString(2)+"</p>";  
     //  buffer="<option value='"+rs.getString(1)+"'>"+rs.getString(2)+"</option>";   
   }  
 
 response.getWriter().println(buffer); 
 }
 catch(Exception e){
     System.out.println(e);
 }
 %>